Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Creating OLAP DML Programs

An OLAP DML program is written in the OLAP DML. It acts on data in the analytic workspace and helps you accomplish some workspace management or analysis task. You can write OLAP DML programs to perform tasks that you must do repeatedly in the analytic workspace, or you can write them as part of an application that you are developing.

To create an OLAP DML program, take the following steps:

1. Issue a DEFINE PROGRAM statement to define the program object. When the program that you are defining will be used is a function, include the datatype or the dimension argument.

2. Add contents to the program that specify the processing that you want performed as described in "Specifying Program Contents".

3. Compile the program as described in "Compiling Programs".

4. Test and debug the program as described in "Testing and Debugging Programs".

5. Execute the program as described in "Executing Programs".